/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package com.mycompany.oj.Mapper;

import com.mycompany.oj.entity.studentInformation;
import java.util.List;
import java.util.Map;

/**
 *
 * @author wucy
 */
public interface StudentMapper {
    //获取学生信息

    public List<Map<String, Object>> get_student_information(String id);

    //修改手机号
    public int changePhonenumber(String username, String id);

    //修改密码
    public int changePassword(String password, String id);

    //获取做过的题目
    public List<Map<String, Object>> getPostNumber(String id);

    //获取通过的题目
    public List<Map<String, Object>> getPassNumber(String id);

    //获取今日计划
    public List<Map<String, Object>> getTodayNumber(String id);

    //获取做题目标
    public List<Map<String, Object>> getPlanNumber(String id);

    //修改计划
    public int updatePlanNumber(String username, String number);

    //获取哪个人什么难度的题目完成了几道
    public List<Map<String, Object>> finishQuestionNumber(String username, String kind);

    //获取哪个人什么难度的题目完成了几道
    public List<Map<String, Object>> questionNumber(String username, String kind);

    //获取收藏夹
    public List<Map<String, Object>> getFavorites(String username);

    //获取做对的题号
    public List<Map<String, Object>> getTrueQuestion(String username);

    //获取做错的题号
    public List<Map<String, Object>> getFalseQuestion(String username);

    //获取各个难度题数
    public List<Map<String, Object>> getDifficultNumber(String username);

    //修改个人信息
    public int changeStudentInformation(studentInformation student_information, String username);

    //获取最近的做题信息
    public List<Map<String, Object>> getFiveQuestion(String username);

    //获取收藏夹
    public List<Map<String, Object>> getFavoritesJia(String username);

    //创建做题记录
    public int insertGoGoGo(String student_id, String question_id);

    public int insertGoGoGoCourse(String student_id, String question_id);

    //获取时间空间结果
    public List<Map<String, Object>> getTimeMemory(String id);

    public List<Map<String, Object>> getTimeMemoryCourse(String id);
    
    //获取题目ID
    public List<Map<String, Object>> getCourseId(String name);
    
    public List<Map<String, Object>> getQuestionId(String name);
}
